CREATE TABLE [dbo].[sick_area] (
  [sick_area_id] bigint  IDENTITY(1,1) NOT NULL,
  [source_id] nvarchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [sick_name] nvarchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [remark] nvarchar(60) COLLATE Chinese_PRC_CI_AS  NULL,
  [status] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL,
  [del_flag] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL,
  [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [create_time] datetime2(7)  NULL,
  [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [update_time] datetime2(7)  NULL,
  CONSTRAINT [PK__his_sick__3213E83FF31C85CF] PRIMARY KEY CLUSTERED ([sick_area_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[sick_area] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'自增ID',
'SCHEMA', N'dbo',
'TABLE', N'sick_area',
'COLUMN', N'sick_area_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'病区名称',
'SCHEMA', N'dbo',
'TABLE', N'sick_area',
'COLUMN', N'sick_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'病区第三方id',
'SCHEMA', N'dbo',
'TABLE', N'sick_area',
'COLUMN', N'source_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'0启用1禁用',
'SCHEMA', N'dbo',
'TABLE', N'sick_area',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'0正常1删除',
'SCHEMA', N'dbo',
'TABLE', N'sick_area',
'COLUMN', N'del_flag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sick_area',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'sick_area',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sick_area',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新者',
'SCHEMA', N'dbo',
'TABLE', N'sick_area',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'sick_area',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'病区表，一般对接第三方',
'SCHEMA', N'dbo',
'TABLE', N'sick_area'